create table sys_job_log
(
    job_log_id     bigint identity
        constraint PK__sys_job___0CA0EBC98DC75E3C
            primary key,
    job_name       nvarchar(64)  not null,
    job_group      nvarchar(64)  not null,
    invoke_target  nvarchar(500) not null,
    job_message    nvarchar(500),
    status         nchar
        constraint DF_sys_job_log_status default '0',
    exception_info nvarchar(2000)
        constraint DF_sys_job_log_exception_info default '',
    create_time    datetime2(0)
)
go

exec sp_addextendedproperty 'MS_Description', '定时任务调度日志表', 'SCHEMA', 'dbo', 'TABLE', 'sys_job_log'
go

exec sp_addextendedproperty 'MS_Description', '任务日志ID', 'SCHEMA', 'dbo', 'TABLE', 'sys_job_log', 'COLUMN', 'job_log_id'
go

exec sp_addextendedproperty 'MS_Description', '任务名称', 'SCHEMA', 'dbo', 'TABLE', 'sys_job_log', 'COLUMN', 'job_name'
go

exec sp_addextendedproperty 'MS_Description', '任务组名', 'SCHEMA', 'dbo', 'TABLE', 'sys_job_log', 'COLUMN', 'job_group'
go

exec sp_addextendedproperty 'MS_Description', '调用目标字符串', 'SCHEMA', 'dbo', 'TABLE', 'sys_job_log', 'COLUMN',
     'invoke_target'
go

exec sp_addextendedproperty 'MS_Description', '日志信息', 'SCHEMA', 'dbo', 'TABLE', 'sys_job_log', 'COLUMN', 'job_message'
go

exec sp_addextendedproperty 'MS_Description', '执行状态（0正常 1失败）', 'SCHEMA', 'dbo', 'TABLE', 'sys_job_log', 'COLUMN',
     'status'
go

exec sp_addextendedproperty 'MS_Description', '异常信息', 'SCHEMA', 'dbo', 'TABLE', 'sys_job_log', 'COLUMN',
     'exception_info'
go

exec sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 'sys_job_log', 'COLUMN', 'create_time'
go

INSERT INTO [ry-vue].dbo.sys_job_log (job_log_id, job_name, job_group, invoke_target, job_message, status, exception_info, create_time) VALUES (1, N'系统默认（无参）', N'DEFAULT', N'ryTask.ryNoParams', N'系统默认（无参） 总共耗时：3毫秒', N'0', null, N'2021-12-04 13:16:20');